package com.data.app.pojo.pg;

import com.data.app.commons.constant.CommonConstant;
import lombok.Data;
import lombok.ToString;
import org.geolatte.geom.Geometry;

import javax.persistence.*;
import java.math.BigDecimal;
import java.util.Objects;

@Data
@Entity
@Table(name = CommonConstant.TABLE_NAME_BRIDGE, schema = "public", catalog = "sharedata")
public class BridgeEntity {
    @Id
    @Column(name = "bh", nullable = true, length = -1)
    private String bh;//唯一主键
    @Column(name = "province", nullable = true, length = -1)
    private String province;//省（市 区）
    @Column(name = "city", nullable = true, length = -1)
    private String city;//市（州 盟）
    @Column(name = "district", nullable = true, length = -1)
    private String district;//县（市 区 旗）
    @Column(name = "town", nullable = true, length = -1)
    private String town;//乡（镇街道）
    @Column(name = "qlmc", nullable = true, length = -1)
    private String qlmc;//桥梁名称
    @Column(name = "qllb", nullable = true, length = -1)
    private String qllb;//桥梁类别
    @Column(name = "jsfy", nullable = true, length = -1)
    private BigDecimal jsfy;//工程投资
    @Column(name = "kzld", nullable = true, length = -1)
    private String kzld;//原抗震设防烈度
    @Column(name = "xkzsfld", nullable = true, length = -1)
    private String xkzsfld;//(新)现抗震设防烈度
    @Column(name = "sfkzdb", nullable = true, length = -1)
    private String sfkzdb;//(新)抗震是否达标
    @Column(name = "qlzc", nullable = true, length = -1)
    private BigDecimal qlzc;//(新)桥梁长度
    @Column(name = "aqpddj", nullable = true, length = -1)
    private String aqpddj;//(新)安全评定等级
    @Column(name = "cztqqbldz", nullable = true, length = -1)
    private String cztqqbldz;//桥区不良地质
    @Column(name = "cztsfhp", nullable = true, length = -1)
    private String cztsfhp;//是否存在滑坡、泥石流灾害
    @Column(name = "shape", nullable = true, length = -1)
    private Geometry shape;//矢量线
    @Column(name = "fxpc_xzqhbma_sjgl", nullable = true, length = -1)
    private String fxpcXzqhbmaSjgl;//行政区划编码省
    @Column(name = "fxpc_xzqhbmb_sjgl", nullable = true, length = -1)
    private String fxpcXzqhbmbSjgl;//行政区划编码市
    @Column(name = "fxpc_xzqhbmc_sjgl", nullable = true, length = -1)
    private String fxpcXzqhbmcSjgl;//行政区划编码县
    @Column(name = "fxpc_updatetime_sjgl", nullable = true, length = -1)
    private String fxpcUpdatetimeSjgl;//更新时间
    @Column(name = "fxpc_createtime_sjgl", nullable = true, length = -1)
    private String fxpcCreatetimeSjgl;//写入时间
    @Column(name = "fxpc_sjzt_sjgl", nullable = true, length = -1)
    private String fxpcSjztSjgl;//数据状态
    @Column(name = "fxpc_shlczt_sjgl", nullable = true, length = -1)
    private String fxpcShlcztSjgl;//审核流程状态
    @Column(name = "fxpc_shzt_sjgl", nullable = true, length = -1)
    private String fxpcShztSjgl;//审核状态
    @Column(name = "fxpc_sshy_sjgl", nullable = true, length = -1)
    private String fxpcSshySjgl;//所属行业
    @Column(name = "fxpc_rqfp_sjgl", nullable = true, length = -1)
    private String fxpcRqfpSjgl;//日期分片
    @Column(name = "fxpc_pch_sjgl", nullable = true, length = -1)
    private String fxpcPchSjgl;//批次号
    @Column(name = "fxpc_dcdxbm_sjgl", nullable = true, length = -1)
    private String fxpcDcdxbmSjgl;//调查对象编码
    @Column(name = "fxpc_dataid_sjgl", nullable = true, length = -1)
    private String fxpcDataidSjgl;//物理主键

}
